Oracle Interview Questions and Answers
Related differences
Ques 6. What is schema?
A schema is collection of database objects of a user.
Is it helpful?
Add Comment
View Comments
Ques 7. What are Schema Objects?
Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.
Is it helpful?
Add Comment
View Comments
Ques 8. Can objects of the same schema reside in different tablespaces?
Yes
Is it helpful?
Add Comment
View Comments
Ques 9. Can a tablespace hold objects from different schemes?
Yes
Is it helpful?
Add Comment
View Comments
Ques 10. What is Oracle table?
A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users:
- What are the components of physical database structure of Oracle database?
- What are the components of logical database structure of Oracle database?
- What is a tablespace?
- What is SYSTEM tablespace and when is it created?
- Explain the relationship among database, tablespace and data file?